﻿CREATE TABLE [dbo].[Agenti] (
    [IDAgent]     INT          IDENTITY (1, 1) NOT NULL,
    [NumePrenume] VARCHAR (50) CONSTRAINT [DF_Agenti_NumePrenume] DEFAULT ('') NOT NULL,
    [CodUnitate]  SMALLINT     CONSTRAINT [DF_Agenti_CodUnitate] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_Agenti] PRIMARY KEY CLUSTERED ([IDAgent] ASC),
    CONSTRAINT [FK_Agenti_Unitati] FOREIGN KEY ([CodUnitate]) REFERENCES [dbo].[Unitati] ([CodUnitate])
);

